The Inline Xbasic action inserts Xbasic into a script. This should only be used if you know how to use Xbasic. The window that pops up is a Code Editor window with standard features such as bubble help, code completion, and syntax checking.

You can add comments to Xbasic by starting a line with an apostrophe.

Specify Xbasic code to test if the data in this field is valid.

Specify the server-side code (Xbasic) to validate this field value before data are committed to the database.

The Xbasic Explorer is an extremely useful tool when you are writing code in the Code Editor, or experimenting with code in the Interactive window. It is a complete reference of all of the commands, functions, methods, properties and constants in the Xbasic language. It also shows you all of the current objects that exist, all global variables that you have created, and all Global Functions that you have defined.

Alpha Anywhere now supports GUIDs as an intrinsic Xbasic data type (designated as type 'K'), just as Character, Numeric, Logical, Time, etc. are intrinsic Xbasic data types. Support for GUID data types is important for Active-Link tables as some SQL databases use GUIDS for primary keys. You can DIM a variable as a GUID, (e.g. DIM varname as K), or you can use the curly bracket notation to specify a value of type 'K' (just as curly bracket notation is used to specify a Date value). The following Interactive window session shows examples:

The Xbasic Change Record action changes the contents of a record without opening a form or browse. The user does not have to be aware that changes are being made.

Functions and methods for executing Python in an Xbasic script.